Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

Insert Delete Update
1) An UPDATE statement can only modify data of a single table
2) Anything can be inserted as long as the column count and data types match
3) BULK INSERT dbo mybcp
4) Change more than one column by adding a comma and the additional column expression
5) Delete can also be performed using the where clause with joined tables
6) Delete command with conditions
7) Delete rows using IN and subquery
8) Delete with IN operator and subquery
9) Deleting a Row in a Table
10) Insert data returned from a select statement
11) Insert with default value
12) Inserting Images
13) Inserting Rows from Another Table
14) Inserting Several Records in a Query Batch
15) Inserts 12000 rows into a table
16) Inserts 3000 row into a table
17) Inserts one or more rows selected with a subquery
18) Leave column as NULL
19) Managing Inserts Using Stored Procedures
20) Math operator in update statement
21) Modify rows of a table with an expression
22) Reference a declared variable in an update statement
23) The order of the columns in the insert statement
24) TOP Clause in DELETE Statements
25) Update a single column
26) Update a single row
27) Update command with where condition
28) Update more than one columns in update clause
29) Update statement and IN operator
30) UPDATE with a Join
31) Updating a Column Value
32) Updating Rows Based on Multiple Tables
33) Use CASE in the UPDATE statement
34) Using an expression in our UPDATE statement